SELECT *,
OBJECT_DEFINITION(object_id) as definition
 FROM sys.objects WHERE type<>'S' AND type='FN'; 